Query Caching

Pyramid uses caching to speed up the re-use of the same query result set without re-querying the underlying data source for the exact same results. When caching is enabled, the query result set of any previously executed queries is temporarily stored in memory on Pyramid's servers. The length of time for which the query results are stored is set by the administrator in the query cache settings.

The caching that is set for the model here will be the default caching behavior for the data model; users can, however, change this behavior for specified data discoveries. The caching behavior for a visual added to a presentation or publication will reflect the caching set for the query in Discover.

Why Use Query Caching?

Query caching is enabled by default, because it improves speed when executing the same query multiple times. Disabling query caching ensures that query results are up to date (real-time), rather than cached.

Enable or Disable Caching

Caching is enabled by default; toggle the 'Disable Cache' button from the Configuration ribbon or the Tables ribbon to turn of all caching for the data model.

Caching can also be enabled or disabled for the same data model from the source manager in the Admin console, and from Discover.